PSSI Implementation Tracker PSSI Implementation Tracker Process Maps Process Maps Required Documents for Procurement Required Documents for Procurement Activities & Project Proposals Activities & Project Proposals Pacific Salmon Strategy Initiative Pacific Salmon Strategy Initiative Low Code Low Code • • AirTable AirTable • • SharePoint List SharePoint List • • Ragic Ragic DFO DFO SDPA, OCDS, IMTS, IT-Cloud SDPA, OCDS, IMTS, IT-Cloud Objective Objective Process Map Process Map Collaborative Teams, Details and Documents, Working Groups Collaborative Teams, Details and Documents, Working Groups Science – OCR Unstructured - Salmon Modernization Project Science – OCR Unstructured - Salmon Modernization Project EDH EDH IT- Secuirty IT- Secuirty Contracts for Data and Human Resources Contracts for Data and Human Resources Stewardship Directorate (Habitat Restoration Centre of Expert... Stewardship Directorate (Habitat Restoration Centre of Expertise) – OCR Structured – (G&Cs) Phase Phase Strategic Data Analytics Team Strategic Data Analytics Team Data Collection & Meta-Data Data Collection & Meta-Data Knowledge Graph Knowledge Graph Science Data Gaps Science Data Gaps EDH EDH Cloud Architecture Cloud Architecture Software Suites (Data Lineage) Software Suites (Data Lineage) Office of the Chief Data Steward (OCDS) Office of the Chief Data Steward (OCDS) Prospective Consultants Prospective Consultants Data - Lake, Hub, Warehouse, Fabric, Mesh Data - Lake, Hub, Warehouse, Fabric, Mesh Supporting Documents Supporting Documents Team Documents Team Documents Crest / Krest Crest / Krest Team Documents Team Documents Data Stewards Data Stewards Technical Technical Projects Projects AQUIIS AQUIIS Fisheries and Harbour Management (FM) Fisheries and Harbour Management (FM) Data Analytics Team Documents [ O – In Office| X – Away] Data Analytics Team Documents [ O – In Office| X – Away] Science Science IT Security Analysts IT Security Analysts Non-PSPC Verification Approval Non-PSPC Verification Approval PSPC Approved PSPC Approved Pacific Salmon Scanner - Regional Ecosystem Effects Fish & Fi... Pacific Salmon Scanner - Regional Ecosystem Effects Fish & Fisheries Salmon Program Integration Salmon Program Integration OCR OCR Database Mapping Database Mapping Cloud & Data Lake Cloud & Data Lake Steps Steps SPDA Working Groups SPDA Working Groups DG and Management Level DG and Management Level National Data Council (NDC) National Data Council (NDC) Data Stewardship Committee (DSC) Data Stewardship Committee (DSC) Data Governance Steering Committee (DGSC) Data Governance Steering Committee (DGSC) Working Level Working Level Metadata Working Group Metadata Working Group Metadata Best Practices Sub-Working Group Metadata Best Practices Sub-Working Group Reference Data Working Group (RDWG) Reference Data Working Group(RDWG) Data Inventory Working Group (DIWG) Data Inventory Working Group (DIWG) Data Sharing Agreement Working Group (DSAWG) Data Sharing Agreement Working Group (DSAWG) Data Governance Working Group (DGWG) Data Governance Working Group (DGWG) E.g. FM, Science E.g. FM, Science Problem: Our ability to conserve and protect salmon is hamper... Problem: Our ability to conserve and protect salmon is hampered by our inability to deal effectively with complex information.Solution: A knowledge graph is a modern approach to manage and discover information, allowing more fully informed decisions, and ultimately improved salmon conservation.Why was the knowledge graph created?   A knowledge graph was created to map out the connections, or interdependencies, between DFO Pacific region applications that use salmon data, the databases the applications are stored in, the products the applications produce (such as dashboards, briefing notes, data summaries) and ultimately the decisions the data supports. Specifically, a knowledge graph can help solve four key questions:1.What are the salmon data sets and where are they?2.Who collects and consumes the data?3.What products do those data sets feed into? 4.What data sets feed into what decisions?In short, to map how data flows from databases the data stored in to the decisions the data supports. To the best of our knowledge, this task is novel and had never been completed before.  What could you not do before the knowledge graph?   A knowledge graph is a great tool to understand the relationships between nodes, i.e. applications, databases, products and decisions, by connecting the nodes with edges (or arrows). Often in DFO Excel spreadsheets have been used to inventory data and identify connections. While spreadsheets can accurately store the connections between databases, applications etc., they are not great at visually viewing the connections and searching the connections. With spreadsheets we could not easily find and access the connections in a visual way.  What can you 'possibly' do now with the knowledge graph?  With the knowledge graph is its current form we can visually view and understand the relationships between applications, databases, and products to support decision-making through analytics. Relationships between entities will provide insight, trends and interconnections that may have never been considered, therefore leveraging data collaboration among data stewards, improving data harmonization standards and removing redundancies. Proactive vs Reactive: Significant changes performed by data stewards to their respective data values will provide real-time deterministic impact to the relationship among databases. This will inform and challenge whether these changes align with the teams business strategy and offers instant feedback. Through an automated process, the A.I package will constantly scan and review the relationships among the various databases. This will ensure that data management is continually driven in an efficient way. Priyadarshi Pal Data Architect Priyadarshi PalData Architect (Prior work - Marine Spatial Planning, Oceans Protection Plan... (Prior work - Marine Spatial Planning, Oceans Protection Plan, Marine Conservation Targets)Metadata summarizes basic information about data, making finding & working with particular instances of data easier. Metadata is needed to have a generalized structure of the information and what is being collected· Metadata Best Practices Working Guide Science-specific data gaps and their data stewards Salmon Dat... Science-specific data gaps and their data stewards· Salmon Data Gaps and Issues David Goa Data Engineer David GoaData Engineer Tan Tran Senior Data Advisor Tan TranSenior Data Advisor KPI’s KPI’s (Vacant) Cloud Engineer (Vacant)Cloud Engineer IT SEC IT SEC (Vacant) Cloud Architect (Vacant)Cloud Architect Strategic Data Governance & Policy Team Strategic Data Governance & Policy Team Vacant Strategic Data Advisor VacantStrategic Data Advisor Chief Digital Office Sector (CDOS) [Formerly IMTS] Chief Digital Office Sector (CDOS) [Formerly IMTS] Department of Fisheries and Oceans The Pacific Salmon Strateg... Department of Fisheries and OceansThe Pacific Salmon Strategy Initiative is a major transformational initiative intended to stem the decline of priority Pacific salmon populations and to assist the rebuilding of stocks to sustainable levels. While the management of Pacific salmon is focused on five species of Pacific salmon within the Pacific Region, various sectors and branches throughout the Department have policy and program responsibilities related to Pacific Salmon. As part of the Pacific Salmon Strategic Initiative roadmap, we are in the process of implementing a cloud infrastructure of all salmon-related data. The purpose for this initiative is to deploy strategic-informed decisions that are data-driven and supported by science. Currently, salmon-related data sources vary in different levels of complications; either data is inconsistent, have access issues, are siloed on prem, disconnected relationships among databases/datasets, or insufficient tracing to single source of truth to name a few, the cloud infrastructure objective is to solve these issues. Data Policy team - Inventory log Data Policy team - Inventory log Data Inventory, Business Meta and Prioritization (All Salmon-... Data Inventory, Business Meta and Prioritization (All Salmon-related Data) Data Catalogue Data Catalogue TigerGraph TigerGraph Neo4J Neo4J Mapster Mapster Data Cleaning (Harmonization/Normalization) Data Cleaning (Harmonization/Normalization) Peter Lunka A-Senior Data Policy Analyst Peter LunkaA-SeniorData Policy Analyst EDH Portal EDH Portal EDH API (Operational Database) EDH API (Operational Database) Ingest data – Meta data -> map out fields -> determine values... Ingest data – Meta data -> map out fields -> determine values/range (KPI) -> harmonize fields OR normalize data [consistency] -> map out relationships (nodes) – Correlation threshold (link prediction) with software suites like Neo4J map -> ML connection CLAMS CLAMS Policy and Results Team Policy and Results Team Project Requirements Project Requirements Assessment of OCR Vendors Assessment of OCR Vendors Security Security HR HR Justification Justification Time Time Cost Cost Approval and Procurement Approval and Procurement Security Security Cloud Cloud Tobias Spears A/Manager / Head Office of the Chief Data Steward Tobias SpearsA/Manager / HeadOffice of the Chief Data Steward Data Migration - SQL Data Migration - SQL George Esper Manager Database & Data Administration George EsperManagerDatabase & Data Administration Analytics Analytics Cloud Ingestion Cloud Ingestion Data Sources + Metadata Data Sources + Metadata Karen Starkie Data Modeler/ Business Analyst Karen StarkieData Modeler/Business Analyst Procurement Procurement Data Mesh/Fabric Data Mesh/Fabric Funding Funding Kayla Suhan Aquatic Science Technician Kayla SuhanAquatic Science Technician Nick Bolingbroke EG-04 Technician Nick BolingbrokeEG-04 Technician Field Technicians Field Technicians NuSEDS NuSEDS Stream Inspection Logs (SIL) Stream Inspection Logs (SIL) Output – Strategic Advice Output – Strategic Advice Network Access Control List Network Access Control List Clean Data Clean Data Microsoft Purview Microsoft Purview Denodo Denodo Access Database (South Coast Servers) Access Database (South Coast Servers) Scanning Scanning South Coast Staff (e.g. Nicolette) South Coast Staff (e.g. Nicolette) Excel sheet Excel sheet Callibra Callibra Data stewards and users Data stewards and users Azure Data Lake Azure Data Lake MetaData MetaData Data Stewards Data Stewards EDH Data Catalogue Portal EDH Data Catalogue Portal Informatica Informatica EDH API (Operational Database) EDH API (Operational Database) Database 2 Database 2 Database 1 Database 1 Database (n) Database (n) Federal Geospatial Platform Federal Geospatial Platform Open Government/Data Portal Open Government/Data Portal EDH & SDPA EDH & SDPA Technical MetaData Technical MetaData API API Data Catalogue Data Catalogue Data Cleaning (Harmonization/Normalization) Data Cleaning (Harmonization/Normalization) Single Source of Truth is kept intact Single Source of Truth is kept intact Users Users Output: Software suite app / Data Lake Output: Software suite app / Data Lake ‘Readily-available’ datasets ‘Readily-available’ datasets Ingestion Layer - Performs data migrations via batch and stre... Ingestion Layer - Performs data migrations via batch and streaming methods. We will be using services such as open portals or API pipeline from other cloud services. Review Databases and connect with Data Stewards to determine validity of data integrationStorage Layer - Microsoft Azure Data Lake Storage (Work with Cloud Architect)Catalog Layer Working with IM/IT central catalog services and lake formation if we require data level security approval (SOS)Processing Layer Cloud infrastructure and support of cloud processing - review Microsoft Azure APIConsumption Layer For querying data and exploring data users. For AI we are using TensorFlow to build, train, and deploy models. Models can be exposed as a service to be consumed by apps or will be published. Finally for visualization, Tableau and Power BI. We configured a Power BI gateway so Azure Power BI server can connect to our backends. Vacant Junior Data Analyst VacantJunior Data Analyst Sarah Brooks Junior Data Analyst Co-op Sarah BrooksJunior Data AnalystCo-op (Vacant) Data Engineer (Vacant)Data Engineer Business Glossary and Standards Identification Business Glossary and Standards Identification Data as an Asset Project – Valuing databases and datasets acr... Data as an Asset Project – Valuing databases and datasets across the Pacific Complete Data to Decisions Map using Business MetaData and In... Complete Data to Decisions Map using Business MetaData and Inventory Database Examples Database Examples • • MySql MySql • • Postgres Postgres • • SQLite SQLite • • MariaDB MariaDB External Portal Examples: External Portal Examples: • • Pacific Salmon Foundation Pacific Salmon Foundation • • Canada Energy Regulatory #1 Canada Energy Regulatory #1 • • Canada Energy Regulatory #2 Canada Energy Regulatory #2 • • Statistic Canada Statistic Canada • • Natural Resource Canada #1 Natural Resource Canada #1 • • Natural Resource Canada #2 Natural Resource Canada #2 Microsoft Azure Catalog Microsoft Azure Catalog DFO’s EDH (In Development) DFO’s EDH (In Development) Internal Portal Examples: Internal Portal Examples: • • ThinkData ThinkData • • Tableau Tableau • • • • Adastra – RFP/RFQ Contract (procurement) Adastra – RFP/RFQ Contract (procurement) Adastra Overview and Capabilities Adastra Overview and Capabilities Kevin O’Connor Business Analyst Kevin O’Connor Business Analyst EDH Onboarding Methodologies EDH Onboarding Methodologies Document Recovery Project Document Recovery Project Document Dissector PoC Document Dissector PoC Cloud Data Cloud Data David Collister A/Manager Office of the Chief Data Steward David CollisterA/ManagerOffice of the Chief Data Steward Justin Mundy Lead Justin MundyLead Storage Storage Scanning Scanning Completion Date: Expected November Completion Date: Expected November Implementation Implementation Extraction Extraction Review Review UI UI JSON JSON Field Experts (in House) / Outsourced Field Experts (in House) / Outsourced Data to Decisions Data to Decisions Document Dissector PPT Document DissectorPPT Databases Databases Document Overview Cloud Request Document OverviewCloud Request ReadMe Data Redundancy ReadMeData Redundancy Security Security Guy Demers A/Team Leader, Risk Management Guy DemersA/Team Leader, Risk Management Simon Dufour Lead Simon DufourLead Azure Data Catalogue Suite Azure Data Catalogue Suite Business Management Integration and Engagement Business Management Integration and Engagement Vacant Solutions Architect VacantSolutions Architect Erfan Ahmed Project Manager Erfan AhmedProject Manager Christene Ostapczuk IT Technical Advisor Christene OstapczukIT Technical Advisor Daniel Warkentin A/ Manager (Technical Advisor) Daniel WarkentinA/ Manager (Technical Advisor) Richard Kiefl A/ Director IMTS Richard KieflA/ Director IMTS Application Rationalization Initiatives Application Rationalization Initiatives Tim Mattimoe Manager Database, Applications & Platforms Servi... Tim MattimoeManagerDatabase, Applications & Platforms Services Business Intake / Proposal Business Intake / Proposal ETL ETL PSSI Digital Salmon Data Integration (Data Repository) PSSI Digital Salmon Data Integration (Data Repository) Spatial vs Non-Spatial Data Spatial vs Non-Spatial Data Data Inventory Data Inventory Vacant EC-02 Junior Data Analyst VacantEC-02Junior Data Analyst Aswea Porter Aquatic Science Biologist South Coast Aswea Porter Aquatic Science BiologistSouth Coast Erin Rechisky Section Head - Aquatic Science Biologist South ... Erin RechiskySection Head - Aquatic Science BiologistSouth Coast PSSI IT Requirements Survey PSSI IT Requirements Survey Brenda McIntyre Manager Intake - Software Solutions Brenda McIntyreManagerIntake - Software Solutions Chris O’Grady GIS and Data Coordinator Chris O’GradyGIS and Data Coordinator Krista, Sandberg Senior Data and Public Reporting Coordinator Krista, SandbergSenior Data and Public Reporting Coordinator Faith Yu Service Manager Faith YuService Manager Dana Hsu Fishery Information Assistant Dana HsuFishery Information Assistant Data Priority Framework Data PriorityFramework Pacific Data Lakehouse Identification of Early Adopters Pacific Data LakehouseIdentification of EarlyAdopters Metadata Project Metadata Project Karin Mathias Data Analytics Lead South Coast Karin MathiasData Analytics LeadSouth Coast John Davidson Data Analyst John DavidsonData Analyst Martin Huang Data Analyst Martin HuangData Analyst PACHarv-3 Process Map PACHarv-3Process Map AMD Process Map AMDProcess Map C/K rest Process Map C/K restProcess Map NuSEDS Process Map NuSEDSProcess Map Reed Orpen Junior Programmer South Coast Reed OrpenJunior ProgrammerSouth Coast Sue Grant Program Head Sue GrantProgram Head Bronwyn MacDonald Analytical Biologist Bronwyn MacDonaldAnalytical Biologist Data Management Services - Comparisons Data ManagementServices - Comparisons Scanner Process Map ScannerProcess Map DFO-PSSI Data Lake DFO-PSSIData Lake IT-Security Requirements IT-Security Requirements SOS SOS SRCL SRCL ISO27017 ISO27017 ISO27018 ISO27018 SOC2 – Type II SOC2 – Type II ISO 27001 ISO 27001 Signature-Approval Signature-Approval Audit Checklist PBML System Support Team Audit Checklist PBMLSystem Support Team Audit Checklist PBML PSDM Audit Checklist PBMLPSDM Audit Compliance Evidence Audit ComplianceEvidence Cloud SaaS PBML System Support Team Cloud SaaS PBMLSystem Support Team NuSEDS / FOS NuSEDS / FOS Kayla Suhan Aquatic Science Technician Kayla SuhanAquatic Science Technician Yi Xu Program Head Yi XuProgram Head Graham Van der Slagt Strategic Advisor Graham Van der SlagtStrategic Advisor Jaimi Gardner Manager Jaimi GardnerManager Christian Guay Regional Security Officer Christian GuayRegional Security Officer Data Priority Framework Weight Data PriorityFramework Weight Map Standardized Operating Procedures (Process Map) Map Standardized Operating Procedures (Process Map) Extract Operational and Functional issues Extract Operational and Functional issues Group and categorize issues Group and categorize issues Consult with IMTS Team - Cross reference with PSSI-IT Survey Consult with IMTS Team - Cross reference with PSSI-IT Survey Audit - Extract outstanding issues & create Use-Case Audit - Extract outstanding issues & create Use-Case Report to Management & Present issues with proposed solutions Report to Management & Present issues with proposed solutions Funding Funding Deploy Strategic Operations (internal/external) Deploy Strategic Operations (internal/external) A/Director Cyber Security A/Director Cyber Security Remi Gagnon Cybersecurity Risk Management Remi GagnonCybersecurity Risk Management Manager Manager Eric Louis-Seize Cybersecurity Risk Management Eric Louis-SeizeCybersecurity Risk Management Consult with IT Teams (i.e. IMTS/IT/EDH/Cloud/SEC) Consult with IT Teams (i.e. IMTS/IT/EDH/Cloud/SEC) Create proposed IT-solutions Create proposed IT-solutions Eric Quan Eric Quan Daniel Warkentin DanielWarkentin Dennis Klassen Senior Advisor Dennis KlassenSenior Advisor Jessica Chan Program Advisor Jessica ChanProgram Advisor Reggie Gill Program Officer Reggie GillProgram Officer Rishika Selvakumar Program Assistant Rishika SelvakumarProgram Assistant Piper-Lynn Brady Salmon Stock Assessment Technician South Coast Piper-Lynn BradySalmon Stock Assessment TechnicianSouth Coast Vacant EC-05 Data Analyst VacantEC-05Data Analyst Informatica Informatica Riham Elhabyan Senior Policy Advisor Riham ElhabyanSenior Policy Advisor Lee Croft Analyst Lee CroftAnalyst Ayan Qadir Junior Data Analyst Co-op Ayan QadirJunior Data AnalystCo-op Data Stories Examples Data Stories Examples • • • • • • AmCharts COVID AmCharts COVID NASA Images NASA Images PhD Gender Gap PhD Gender Gap Olivier Sabourin Senior Data Specialist Olivier SabourinSenior Data Specialist Tan Tran Senior Data Advisor PSSI Tan TranSenior Data AdvisorPSSI Julian Kirby Senior Policy Advisor Julian KirbySenior Policy Advisor OCDO Committees OCDO Committees PSSI Recreational Catch Monitoring – Data IT Sub Group PSSI Recreational Catch Monitoring – Data IT Sub Group Artificial Intelligence Working Group (AI WG) Artificial Intelligence Working Group(AI WG) Regional Data Council (RDC) Regional Data Council (RDC) Strategic Data Working Group Strategic Data Working Group Regional Spatial Data Coordination WG Regional Spatial Data Coordination WG DFO - Procurement Team DFO - Procurement Team Required Documents Required Documents Option #1) Consultants – Services (SaaS) Option #1) Consultants – Services (SaaS) Option #3) Software Acquisitions (Stand alone) – On Prem Option #3) Software Acquisitions (Stand alone) – On Prem Option #2) Software Acquisitions – On Cloud (SaaS) Option #2) Software Acquisitions – On Cloud (SaaS) Sole Source Sole Source CDOS CDOS Director Director Senior Manager Senior Manager Contract Officer Contract Officer Team Leader Contracting Officer Team LeaderContracting Officer Contracting Officer Contracting Officer Resource Planning Officer Resource Planning Officer HR Documents – Onboarding HR Documents – Onboarding Students Students Procurement Services Hub Forms Procurement Services Hub Forms RFP RFP Hub Officer Hub Officer ACAN ACAN Term/Casual/Indeterminate Term/Casual/Indeterminate PSSI Recreational Catch Monitoring WG PSSI Recreational Catch Monitoring WG EDH Data Catalogue EDH Data Catalogue Eric’s Files Eric’s Files Onboarding Material Onboarding Material Data Inventory (DMApps) Data Inventory (DMApps) Structured Structured Unstructured Unstructured Data Portal Data Portal Seating Plan Bookings Seating Plan Bookings Sr Procurement Officer Sr Procurement Officer Products Products Project Architecture Project Architecture PSSI with Science PSSI with Science Data Science & Advanced Analytics Data Science & Advanced Analytics Engagement and Learning Engagement and Learning Tools, Resources and Guides Tools, Resources and Guides Project Plans Project Plans SDPA SDPA PSTB - Restoration Centre of Expertise PSTB - Restoration Centre of Expertise EMB – Integrated Planning for Salmon Ecosystem (IPSE) EMB – Integrated Planning for Salmon Ecosystem (IPSE) EMB – Fish and Fish Habitat Protection Program (FFHPP) EMB – Fish and Fish Habitat Protection Program (FFHPP) FM - Quebec FM - Quebec Stock Assessment Stock Assessment Data Quality Data Quality Data Ethics and Responsible AI Working Group (DERAI WG) Data Ethics and Responsible AI Working Group(DERAI WG) DFO-PSSI-HR and Administration DFO-PSSI-HR and Administration HR Branch HR Branch Fast-Track Fast-Track OCDS Documents OCDS Documents Muna Sayid Procurement Specialist Muna SayidProcurement Specialist Mallorie Dawson Team Lead Procurement Specialist Mallorie DawsonTeam LeadProcurement Specialist Adastra Overview and Capabilities Adastra Overview and Capabilities Software Licensing Supply Arrangement Software Licensing Supply Arrangement Buy and Sell Buy and Sell RFP – Task-Based Information Professional Services (TBIPS) RFP – Task-Based Information Professional Services (TBIPS) RFP – Task and Solutions Professional Services (TSPS) RFP – Task and Solutions Professional Services (TSPS) Sole-Source (DFO) < $40K Sole-Source (DFO) < $40K RFP Process RFP Process SOMC / SOW SOMC / SOW Purchase Requisition Purchase Requisition Cost Centre Manager Cost Centre Manager Mandatory / Flex Grid Mandatory / Flex Grid SOSA – Standing Offer and Supply Arrangements Application SOSA – Standing Offer and Supply Arrangements Application Contract or Software License Deadlines – who can we contact? Contract or Software License Deadlines – who can we contact? Assyst Assyst ACAN – Advance Contract Award Notice <15 calendar days ACAN – Advance Contract Award Notice <15 calendar days Buy and Sell Buy and Sell Statement of Capability – Will extend ACAN to 30 days Statement of Capability – Will extend ACAN to 30 days RC Delegated Manager < $20k RC Delegated Manager < $20k PSPC Contract >25K – requires 3 months PSPC Contract >25K – requires 3 months SSC (If falls within Mandate) SSC (If falls within Mandate) PSPC PSPC PSPC - Delegation PSPC - Delegation assigned assigned DFO – Procurement Services DFO – Procurement Services Sole-Source (DFO) < $200K Sole-Source (DFO) < $200K Request Eric to send email about dedicated PSSI Procurement O... Request Eric to send email about dedicated PSSI Procurement Officer to Mallorie – Include Matt and Christophe SOW SOW Sole Source Justification Sole Source Justification Quote from Vendor Quote from Vendor Security Requirement Check List (SRCL) Security Requirement Check List (SRCL) Intellectual Property Form Intellectual Property Form Francis Gosselin Francis Gosselin Patrizia Marinelli Patrizia Marinelli Joanne Lynch Joanne Lynch Nancy Savaria Nancy Savaria Meenu Bhatia Meenu Bhatia Christine Demers Christine Demers List of validated Post-Secondary Academic Institutions and Pr... List of validated Post-Secondary Academic Institutions and Programs SOW SOW Security Requirement Check List (SRCL) Security Requirement Check List (SRCL) Intellectual Property Form Intellectual Property Form Procurement Intake Form Procurement Intake Form SOW SOW Security Requirement Check List (SRCL) Security Requirement Check List (SRCL) Intellectual Property Form Intellectual Property Form Quote from Vendor Quote from Vendor Advertising - Poster Advertising - Poster SPDA SOMC – EC05 SPDA SOMC – EC05 All-in-one non-advertised form All-in-one non-advertised form Job Description Analytics Team Job DescriptionAnalytics Team Student Salary Student Salary SFU Contact SFU Contact UBC Contact UBC Contact HR DFO-PSSI HR DFO-PSSI Kellina Lang HR Administrator Kellina LangHR Administrator Sherry Luo Strategic Data Analyst Sherry LuoStrategic Data Analyst Audit Audit Analytics Team SOMC – EC05 Analytics Team SOMC – EC05 Roles & Responsibilities Roles & Responsibilities Pacific Salmon Data Modernization Charter Pacific Salmon DataModernizationCharter 2. Salmon 101 Deck (June 2022) 2. Salmon 101 Deck (June 2022) 3. PSSI Information Session 3. PSSI InformationSession 1. Onboarding Handbook 1. Onboarding Handbook 4. PSEC (July 2022) 4. PSEC (July 2022) 5. PSSI (Dec 2021) 5. PSSI (Dec 2021) 6. PSSI Data & IT 6. PSSI Data& IT 7. Strategic Data Workshop (2022) 7. Strategic DataWorkshop (2022) 2023 PSSI Project Charter Pacific Salmon Data Portal (March 23) 2023 PSSI Project Charter Pacific Salmon Data Portal (March 23) DMApps DMApps Azure Purview Access Azure Purview Access Azure Blob Portal Azure Blob Portal Competitive Solicitated Contract Competitive Solicitated Contract Task Authorization Contract Task Authorization Contract Standing Offer Standing Offer Supply Arrangement Supply Arrangement Acquisition Card Acquisition Card Contractual Arrangements Contractual Arrangements 2023 Pacific Salmon Management Activities Matrix 2023 Pacific Salmon Management Activities Matrix Project Charter Pacific Salmon Portal Project Charter Pacific Salmon Portal Data Portal - Internal Data Portal - Internal Science Branch Overview (2023) Science BranchOverview (2023) Generic Welcome Email Generic WelcomeEmail Data Inventory Web App Proposal Data Inventory Web App Proposal DMApps Documentation DMAppsDocumentation Data Hub Instructions & Background Data Hub Instructions & Background OCR SOW OCR SOW IT-SEC Requirements IT-SECRequirements Sprints Sprints OCR Proposal OCR Proposal RFP Criteria Evaluation RFP Criteria Evaluation Presentation Presentation Data Portal Data Portal Cynthia Logan Lead Advisor Cynthia LoganLead Advisor Marisa Ramey A/ Senior Data Analyst Marisa RameyA/ Senior Data Analyst Vacant Logistics Coordinator VacantLogistics Coordinator Dat Pham Data Analyst Dat PhamData Analyst Vacant Policy Advisor/Economist VacantPolicy Advisor/Economist PowerBI API Connections PowerBI API Connections Code Code WG Participation List WG Participation List Samples Samples Pacific Salmon Data Internal Engagement Pacific Salmon DataInternal Engagement RDC Presentation 2022 RDC Presentation2022 ClickUP ClickUP RDC Presentation 2023 RDC Presentation2023 Samples Samples David Onak Data Analyst David OnakData Analyst Bassam El-Daya Bassam El-Daya What is a DataLake? What isa DataLake? Patrick Gunville Manager EDH Onboarding Patrick GunvilleManagerEDH Onboarding Tarun Bagga Consultant Artificial Intelligence Tarun BaggaConsultantArtificial Intelligence Jaswinder Singh Consultant Data Modeller Jaswinder SinghConsultantData Modeller Azure Storage Guide Azure StorageGuide PaRR PaRR Summary of Proposals Summary of Proposals Joel Harding Section Head Joel HardingSection Head Kayi Chan Sr Geo-Spatial and Database Specialist Kayi ChanSr Geo-Spatial andDatabase Specialist Natalie Mahara Restoration Biologist Natalie MaharaRestoration Biologist G&C Final Reports G&CFinal Reports OCR Proposal OCR Proposal PoC Requirements PoC Requirements Document Intelligence Document Intelligence SQL Warehouse Databricks SQL WarehouseDatabricks Azure Databricks ML AzureDatabricks ML Azure OpenAI subscription Azure OpenAI subscription Pipeline Pipeline Model Model Azure Storage (Gold) Azure Storage(Gold) Project-ID Project-ID Azure Storage (Bronze) AzureStorage(Bronze) Open Document types -> PDF Open Document types -> PDF Azure Databricks (Code) AzureDatabricks(Code) Save tables Save tables Cloud Services Innovation Request Cloud Services Innovation Request Save Save Output Output Data Dictionary Data Dictionary Saved as table Saved as table Data Analytics Team Who are we? Data Analytics TeamWho are we? Dashboards & Reports Dashboards& Reports SPDA SOMC – EC02 SPDA SOMC – EC02 Khaled Sultani Analyst Khaled SultaniAnalyst Project Architecture Swimlanes Project ArchitectureSwimlanes Ann-Marie Huang Management Strategy Evaluation Analyst Ann-Marie HuangManagement Strategy Evaluation Analyst Diana Dobson Stock Assessment Biologist Diana DobsonStock AssessmentBiologist State of the Salmon Resource State of the Salmon Resource Form-implementation Flow diagram Form-implementationFlow diagram ERD ERD DFO All Staff Deck DFO All StaffDeck Salmon Outlook 2023 Salmon Outlook2023 Roles & Responsibilities Roles & Responsibilities DFO-PSSI Power Point Template DFO-PSSI Power PointTemplate Documents & Presentations Documents&Presentations CDOS Work-level documents CDOSWork-level documents OpenAI Code OpenAICode Access API-Key Access API-Key access access access access access access Diagrams Diagrams PSSI Holiday Tracker PSSI Holiday Tracker OCDS Holiday Tracker OCDS Holiday Tracker Escapement Proposal EscapementProposal Catch and Effort Proposal Catch and EffortProposal Outlook Proposal OutlookProposal Doc2PDF Doc2PDF OCR Final OCR Final Python Learning Series Python LearningSeries Member | Monday | Tuesday |Wednesday | Thursday (O) |Friday T... Member | Monday| Tuesday|Wednesday| Thursday (O)|FridayTan Tran (T)7:00am - 6:00pm7:00am - 6:00pm (O)7:00am - 6:00pm (O)7:00am - 6:00pm7:00am - 6:00pmDavid Onak (D)8:00am - 4:00pm8:00am – 4:00pm (O)8:00am - 4:00pm (O)8:00am - 4:00pm8:00am – 4:00pmHayden Yan (H)9:00am – 5:00pm9:00am – 5:00pm (O)9:00am – 5:00pm (O)9:00am – 5:00pm9:00am – 5:00pm (Flex)Dat Pham (P)9:00am – 5:00pm9:00am – 5:00pm (O)9:00am – 5:00pm9:00am – 5:00pm9:00am – 5:00pm (O)Ayan Qadir(M) 9:00am – 5:00pm9:00am – 5:00pm 9:00am – 5:00pm (O)9:00am – 5:00pm9:00am – 5:00pm (O) Yuchen Wang Senior Policy Advisor Yuchen WangSenior Policy Advisor Organizational Chart Organizational Chart AirTable AirTable OCR Software Assessment OCR Software Assessment Analytics Team SOMC – EC02 Analytics TeamSOMC – EC02 SSC Environment Walk-through SSC Environment Walk-through Hybrid Work Arrangement Agreement Hybrid Work ArrangementAgreement Data Analytics Research Paper Data AnalyticsResearch Paper Generative A.I Generative A.I RCOE Prompt History RCOE Prompt History Azure WebApps Azure WebApps Prompt Engineering PromptEngineering OpenAI-ChatGPT Models and Optimization Research OpenAI-ChatGPT Models and Optimization Research Azure VM Azure VM Personal Identifiable Information Personal IdentifiableInformation OpenAI-ChatGPT LLM Comparisons & Cost Analysis OpenAI-ChatGPT LLM Comparisons&Cost Analysis RCOE RCOE IPSE IPSE FFHPP FFHPP Science Science Eric Quan Manager, Strategic Data Policy and Analytics Eric QuanManager,Strategic Data Policy and Analytics Dan Sherville Strategic Data Advisor Dan ShervilleStrategic Data Advisor Hayden Yan Data Analyst Hayden YanData Analyst OpenAI Reference & Citations OpenAIReference &Citations FM - QC FM - QC FM FM OCR Web Guide OCR WebGuide Josee Chabot Technical Advisor Josee Chabot Technical Advisor Kayi Chan Program Head Kayi ChanProgram Head Joel Harding Section Head Joel HardingSection Head Alston Bonamis Manager Alston BonamisManager Chantelle Caron Section Head Chantelle CaronSection Head Thomas Appleby Senior Biologist Thomas ApplebySenior Biologist Jeska Gagnon Section Head Jeska GagnonSection Head Lisa Stychar Environmental Planner Lisa StycharEnvironmentalPlanner Nathan Ferguson Biologist Nathan FergusonBiologist Jeska Gagnon Section Head Jeska GagnonSection Head Amos Chow Integrated Fisheries Data Manager Amos ChowIntegrated Fisheries Data Manager Vincent Remillard Analyst Vincent RemillardAnalyst Judy Dore Manager Judy DoreManager PMA Template PMA Template Azure Databricks Azure Databricks OCR Script Technical Process OCR ScriptTechnical Process Classify and Extract Model Training Classify and ExtractModel Training OpenAI OpenAI Declan Embury Acting Regional Data Coordinator Declan EmburyActingRegional Data Coordinator Datasets Datasets Contents Contents Minh Doah Database Analyst Minh Doah Database Analyst Zhipeng Wu Technician Zhipeng WuTechnician Tom Bird Research Scientist Tom BirdResearch Scientist Shelee Hamilton Head, Fishery & Assessment Data Section Shelee HamiltonHead, Fishery & Assessment Data Section Nicholas Komick MRP Analytics Program Head Nicholas KomickMRP Analytics Program Head Nick Bolingbroke Technician Nick BolingbrokeTechnician Allan Reyes Consultant – Software Dev Allan ReyesConsultant – Software Dev Neeha Lakkineni Consultant – Software Dev Neeha LakkineniConsultant – Software Dev Omar Ibrahim Manager Omar IbrahimManager Federic Goulet Technical Advisor Federic GouletTechnical Advisor Building ID Badge Building ID Badge Azure Certifications (AZ-900, DP-203, DP-600) Azure Certifications (AZ-900, DP-203, DP-600) Azure Resources (WebApps, Blob Storage, etc) Azure Resources(WebApps, Blob Storage, etc) Google Analytics Google Analytics Project Plans Project Plans PSSI and SDPA PSSI and SDPA Data Portal - External Data Portal - External Salmon Scanner Salmon Scanner MyWork Arrangement MyWork Arrangement Renald Bilodeau Support Analyst Renald BilodeauSupport Analyst Collaborative Services & Productivity Collaborative Services & Productivity Mathieu Chiasson Manager Mathieu ChiassonManager Michael Violin Technical Analyst - Designer Michael ViolinTechnical Analyst - Designer Jacob Zhou Technical Advisor - Dev Jacob ZhouTechnical Advisor - Dev Elyse Giroux Team Lead Elyse GirouxTeam Lead IT Cloud Team IT Cloud Team Céleste Grodesky Team Lead Céleste GrodeskyTeam Lead Oksana Korol Solutions Cloud Architect Oksana KorolSolutions Cloud Architect Alex Imray Papineau Junior Programmer Alex Imray PapineauJunior Programmer Cloud Intake Cloud Intake Cloud Services Innovation Request Forms Cloud Services InnovationRequest Forms Mehtab Chhina Coop Junior Data Analyst Mehtab ChhinaCoopJunior Data Analyst OCDS Training Request OCDS Training Request ClickUp Guidelines ClickUp Guidelines Git Best Practices Git Best Practices Kyle Schellen Coop Junior Data Analyst Kyle SchellenCoopJunior Data Analyst Enterprise Conceptual Architecture Team (ECAT) Enterprise Conceptual Architecture Team (ECAT) Enterprise solution architecture Team (ESAT) Enterprise solution architecture Team (ESAT) Data Architecture Review Board (DARB) Data Architecture Review Board (DARB) Digital Labs Digital Labs Leo Chavez Manager Leo ChavezManager Natalie Murray IT Team Lead Natalie MurrayIT Team Lead Marco Niederegger Developer Marco NiedereggerDeveloper Infrastructure Systems - Mac & Linux Support Team Infrastructure Systems - Mac & Linux Support Team Lawrence Greening IT Analyst Lawrence GreeningIT Analyst Nicolas Kendall, Analyst Nicolas Kendall,Analyst Elaine Chan HR Advisor Elaine ChanHR Advisor Kajal Bhardwaj AS-02 Admin Coordinator Kajal BhardwajAS-02Admin Coordinator Rehal Herpreat CR-04 Administrator Rehal HerpreatCR-04Administrator Coralie Harper CR-04 Administrative Clerk Coralie HarperCR-04Administrative Clerk Ameerah Buksh CR-04 Administrative Clerk Ameerah BukshCR-04Administrative Clerk Roberta King Business Manager Roberta KingBusiness Manager Gavin Ng Finance Administrator Gavin NgFinance Administrator Samuel Ko IT Risk Management Analyst Samuel KoIT Risk Management Analyst Bill Yuan IT Senior Advisor Bill YuanIT Senior Advisor ESAT Agenda & Workflow ESAT Agenda &Workflow Solution Architecture Standards Solution Architecture Standards Cloud Operations and Application Services Cloud Operations and Application Services Marc Desrosiers Manager Marc DesrosiersManager Ghizal Mehdi IT Analyst Ghizal MehdiIT Analyst AD-GROUPS AD-GROUPS A.I Incubator A.I Incubator A.I PSSI + OCDS Usecases A.I PSSI + OCDS Usecases